1 <?php
2 session_start();
3 error_reporting(0);
4 include('includes/config.php');
5 if(strlen($_SESSION['alogin'])==0)
6 {
7 header('location:index.php');
8 }
9 else{
10 ?>
11 <!DOCTYPE HTML>
12 <html>
13 <head>
14 <title>TMS | Admin manage Users</title>
15 <meta name="viewport" content="width=device-width, initial-scale=1">
16 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
17 <script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
18 <!-- Bootstrap Core CSS -->
19 <link href="css/bootstrap.min.css" rel='stylesheet' type='text/css' />
20 <!-- Custom CSS -->
21 <link href="css/style.css" rel='stylesheet' type='text/css' />
22 <link rel="stylesheet" href="css/morris.css" type="text/css"/>
23 <!-- Graph CSS -->
24 <link href="css/font-awesome.css" rel="stylesheet">
25 <!-- jQuery -->
26 <script src="js/jquery-2.1.4.min.js"></script>
27 <!-- //jQuery -->
28 <!-- tables -->
29 <link rel="stylesheet" type="text/css" href="css/table-style.css" />
30 <link rel="stylesheet" type="text/css" href="css/basictable.css" />
31 <script type="text/javascript" src="js/jquery.basictable.min.js"></script>
32 <script type="text/javascript">
33 $(document).ready(function() {
34 $('#table').basictable();
35
36 $('#table-breakpoint').basictable({
37 breakpoint: 768
38 });
39
40 $('#table-swap-axis').basictable({
41 swapAxis: true
42 });
43
44 $('#table-force-off').basictable({
45 forceResponsive: false
46 });
47
48 $('#table-no-resize').basictable({
49 noResize: true
50 });
51
52 $('#table-two-axis').basictable();
53
54 $('#table-max-height').basictable({
55 tableWrapper: true
56 });
57 });
58 </script>
59 <!-- //tables -->
60 <link href='//fonts.googleapis.com/css?family=Roboto:700,500,300,100italic,100,400' rel='stylesheet' type='text/css'/>
61 <link href='//fonts.googleapis.com/css?family=Montserrat:400,700' rel='stylesheet' type='text/css'>
62 <!-- lined-icons -->
63 <link rel="stylesheet" href="css/icon-font.min.css" type='text/css' />
64 <!-- //lined-icons -->
65 </head>
66 <body>
67 <div class="page-container">
68 <!--/content-inner-->
69 <div class="left-content">
70 <div class="mother-grid-inner">
71 <!--header start here-->
72 <?php include('includes/header.php');?>
73 <div class="clearfix"> </div>
74 </div>
75 <!--heder end here-->
76 <ol class="breadcrumb">
77 <li class="breadcrumb-item"><a href="index.html">Home</a><i class="fa fa-angle-right"></i>Manage Users</li>
78 </ol>
79 <div class="agile-grids">
80 <!-- tables -->
81
82 <div class="agile-tables">
83 <div class="w3l-table-info">
84 <h2>Manage Users</h2>
85 <table id="table">
86 <thead>
87 <tr>
88 <th>#</th>
89 <th>Name</th>
90 <th>Mobile No.</th>
91 <th>Email Id</th>
92 <th>RegDate </th>
93 <th>Updation Date</th>
94 </tr>
95 </thead>
96 <tbody>
97 <?php $sql = "SELECT * from tblusers";
98 $query = $dbh -> prepare($sql);
99 $query->execute();
100 $results=$query->fetchAll(PDO::FETCH_OBJ);
101 $cnt=1;
102 if($query->rowCount() > 0)
103 {
104 foreach($results as $result)
105 { ?>
106 <tr>
107 <td><?php echo htmlentities($cnt);?></td>
108 <td><?php echo htmlentities($result->FullName);?></td>
109 <td><?php echo htmlentities($result->MobileNumber);?></td>
110 <td><?php echo htmlentities($result->EmailId);?></td>
111 <td><?php echo htmlentities($result->RegDate);?></td>
112 <td><?php echo htmlentities($result->UpdationDate);?></td>
113 </tr>
114 <?php $cnt=$cnt+1;} }?>
115 </tbody>
116 </table>
117 </div>
118 </table>
119
120
121 </div>
122 <!-- script-for sticky-nav -->
123 <script>
124 $(document).ready(function() {
125 var navoffeset=$(".header-main").offset().top;
126 $(window).scroll(function(){
127 var scrollpos=$(window).scrollTop();
128 if(scrollpos >=navoffeset){
129 $(".header-main").addClass("fixed");
130 }else{
131 $(".header-main").removeClass("fixed");
132 }
133 });
134
135 });
136 </script>
137 <!-- /script-for sticky-nav -->
138 <!--inner block start here-->
139 <div class="inner-block">
140
141 </div>
142 <!--inner block end here-->
143 <!--copy rights start here-->
144 <?php include('includes/footer.php');?>
145 <!--COPY rights end here-->
146 </div>
147 </div>
148 <!--//content-inner-->
149 <!--/sidebar-menu-->
150 <?php include('includes/sidebarmenu.php');?>
151 <div class="clearfix"></div>
152 </div>
153 <script>
154 var toggle = true;
155
156 $(".sidebar-icon").click(function() {
157 if (toggle)
158 {
159 $(".page-container").addClass("sidebar-collapsed").removeClass("sidebar-collapsed-back");
160 $("#menu span").css({"position":"absolute"});
161 }
162 else
163 {
164 $(".page-container").removeClass("sidebar-collapsed").addClass("sidebar-collapsed-back");
165 setTimeout(function() {
166 $("#menu span").css({"position":"relative"});
167 }, 400);
168 }
169
170 toggle = !toggle;
171 });
172 </script>
173 <!--js -->
174 <script src="js/jquery.nicescroll.js"></script>
175 <script src="js/scripts.js"></script>
176 <!-- Bootstrap Core JavaScript -->
177 <script src="js/bootstrap.min.js"></script>
178 <!-- /Bootstrap Core JavaScript -->
179
180 </body>
181 </html>
182 <?php } ?>